
**1 - copie o arquivo de backup para o diretorio c:\MSSQL7\BACKUP***
 

RESTORE DATABASE [Shoulder_Retaguarda] FROM  DISK = N'C:\Linx\LINX_SQL5710\bancos\LINXMATSRV01_db_200505090201.BAK' 
 WITH MOVE 'lx_zero_300_dbdata' TO 'C:\Linx\LINX_SQL5710\bancos\Shoulder_Retaguarda.mdf',
 MOVE 'lx_zero_300_log' TO 'C:\Linx\LINX_SQL5710\bancos\Shoulder_Retaguarda_log.ldf',
 FILE = 1,  
 NOUNLOAD ,  STATS = 10,  RECOVERY ,  REPLACE
go
 

sp_dbcmptlevel "master", 70